using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
namespace QuanLyThietBi.Manager
{
                

    public class TBL_ThietBiManager:QuanLyThietBi.ManagerBase.TBL_ThietBiManagerBase
    {
            public static TBL_ThietBiManager CreateInstant()
            {
                return new TBL_ThietBiManager();
            }
              public DataTable LayDanhSachThietBi()
            {
                string strsql = "select  ROW_NUMBER () Over (order by TB.MaTB) as STT,TB.MaTB, TB.TenTB,TB.ThongTinCauHinh,LTB.TenLoaiTB, DVT.TenDonVi from TBL_ThietBi TB, TBL_LoaiThietBi LTB, TBL_DonViTinh DVT where TB.MaLoaiTB= LTB.MaLoaiTB and TB.MaDonVi=DVT.MaDonVi ";
                return SqlHelper.ExecuteDataTable(Config.ConnectionConfig.ConnectionString, CommandType.Text, strsql);
            }
    }
}
                    
